CREATE  PROCEDURE [dbo].[asi_GetHandlingPrice]

@value decimal(18,4),
@priceCode int

AS

--Attempt to retrieve an appropriate handling charge
SELECT COALESCE(
            (SELECT
                TOP 1 hp.Price
            FROM
                HandlingPrice hp
            WHERE
                hp.MinAmount <= @value
                AND hp.HandlingPriceCode = @priceCode
            ORDER BY hp.MinAmount DESC),
            -1)

GO